Problem Note 60616: Loading a configuration returns "Failed to load current LSF cluster configuration. Details: org.springframework.dao.DataIntegrityViolationException"
 |  |  |  |
When trying to load a configuration in SAS® Environment Manager Grid Manager module, you might receive this error message:
Failed to load current LSF cluster configuration. Details:
org.springframework.dao.DataIntegrityViolationException
org.springframework.dao.DataIntegrityViolationException
When you encounter this problem, the PlatformWebServices.log displays the following message:
ERROR com.platform.pws.webservice.impl.LSFConfigWebServiceImpl.loadLsfConfig(LSFConfigWebServiceImpl.java:239)] Exception occured with details:org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into PWS_LSF_CFG_ELEMENT (ELEMENT_NAME, ELEMENT_TIME, LSF_CFG_ELEMENT_ID) values (?, ?, ?)]; nested exception is org.hibernate.exception.DataException: Could not execute JDBC batch update
If the host is longer than 32 characters, you can use the PGIII Admin tool to circumvent the problem. Manually modify the column width in Postgres for the PlatformWebServices (PWS) database by entering the following:
ALTER TABLE PWS_LSF_CFG_ELEMENT ALTER COLUMN element_name TYPE varchar(100);
Note: You can also access the PWS database from another source to manually modify the column width.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Platform Web Services for SAS | Microsoft® Windows® for x64 | 1.4 | 1.5 | 9.4 TS1M4 | 9.4 TS1M5 |
| 64-bit Enabled AIX | 1.4 | 1.5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 1.4 | 1.5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| HP-UX IPF | 1.4 | 1.5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Linux for x64 | 1.4 | 1.5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Solaris for x64 | 1.4 | 1.5 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-06-28 14:16:09 |
| Date Created: | 2017-06-13 12:29:25 |